Messages posted by: David_D1

I am using the JDBC driver (com.edb.Driver) and setting it up as follows:

CF Data Source Name: EnterpriseDB
Jdbc URL: jdbc:edb://192.168.1.37:5444/stanford
Driver Class: com.edb.Driver
Driver Name: EnterpriseDB
Username: *** (username set)
Password: *** (Password set)

And I get this error:

"Connection verification failed for data source: EnterpriseDB
com.edb.util.PSQLException: The connection attempt failed.
The root cause was that: com.edb.util.PSQLException: The connection attempt failed."

What am I doing wrong?

I am using the latest update (8.1.3.14beta) with the migration toolkit in EDB. I was able to make a connection to the oracle database that we wanted to migrate but found some significant issues with the migration tool that has effectively been a showstopper at this point. Theses issues are:

1. While migrating Shcemas and Tables I noticed loads of errors show the inability to migrate or create certain fields/columns in the oracle database (mainly those of type ORDVIDEO). It seems there is no equivelant type in EDB so it just refuses to make that field/column and then as a resuly we lose all data contained in those fields/columns. We simply cannot have that much data just left out.

2. I have also noticed that even though it says it successfully migrates all triggers/procedures/views/sequences, When I look at the EDB copy of this database none of these are there. We use those items heavily and need them migrated if this is going to be a viable tool for migration.

This is my first two attempts at this migration process and frankly I am not even sure that I am doing this correctly as I have yet to see any real documentation on the migration tool itself. I would love to know if these are known issues, is there a workaround, am I simply misssing steps to prepare for the migration, is there going to be an update that address's these problems if they are a known issue, is there. or will there be documentation one can read to solve these issues?

Please any help on this would be greatly appreciated and also a good feather in EDB's cap as we do business from coast to coast and would love to boast EDB as our primary data solution covering millions of records.