The situation comes about while transferring data from some legacy tables to a new set of tables created to take advantage of hibernate's object relationships. The legacy data is being brought into the program usig standard JDBC. The new tables are being established using Hibernate.

The particular situation is a parts list which would normally have an index to facilitate access to the part. The presence of the index makes the initial load of the 80,000 parts intollerably slow, so the table is initially created without the index.

On the next phase of the load program, when the children of the part are loaded, the index needs to be established. I want to execute a table alteration:



While I could get a separate connection to perform this operation, is there a way to get to Hibernate's connection to perform the JDBC execute?

did you try and look in the docs ? It's mentioned about 5 to 6 places that session.connection() should be used for this.

/max