LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: j thomas

Having failed miserably to get the data I want using ODBC, I'm wondering if it's possible to use a JDBC-ODBC bridge with LAE (there is no JDBC driver for the database).

I've no idea how to get this working. I've tried using a JDBC Query node and I've input the following:

• SqlQueryFieldBindings: empty
• DbUser/DbPassword: same username/password as for the DB Query node
• DbUrl: jdbc:odbc:MyDataSource where MyDataSource is the same as DbService in the DB Query node
• DbDriver: sun.jdbc.odbc.JdbcOdbcDriver - don't know if this is the best driver to use - there seem to be many available

This doesn't work and I get the error "error: java.lang.UnsupportedOperationException".

Any suggestions what I'm doing wrong?

Thanks.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: timonk

Good Day,

It would help if you could post the actual node in question, so we can see all of its contents and perhaps try to use it. Do you have an example graph you could send?

Regards
Timon Koufopoulos
MDA Support.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: j thomas

Thanks for replying so swiftly Timon!

Unless you have Perforce yourself I'm not sure how much use it will be to you but I've attached a brg file with 2 nodes: the DB Query one works and the JDBC Query one doesn't.

The parameters are correct except I've replaced my real DB username and password with 'dbuser' and 'dbpassword'.

'Perforce' is a datasource which is correctly configured on my PC. It uses the Perforce ODBC Driver and is configured automatically if you install P4 Report (a Perforce reporting tool).

LAE does seem to be finding the datasource correctly because I get different errors if I input an invalid datasource name, user name or password.

So do I have the right idea? Do you think it might work with a different Java DB driver or do you think the problem is the Perforce ODBC driver?
Attachments:
Perforce connection examples.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: timonk

J

I apologize for the lack of response, and that your issue has slipped between the cracks. Does it remain an issue?

If so, this is likely still a configuration problem, and I would recommend you contact Support directly at DesktopSupport@MDA-data.com

-Timon

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dwong80

Originally posted by: j thomas
					

Having failed miserably to get the data I want using ODBC, I'm wondering if it's possible to use a JDBC-ODBC bridge with LAE (there is no JDBC driver for the database).


I've no idea how to get this working.  I've tried using a JDBC Query node and I've input the following:


SqlQueryFieldBindings: empty
DbUser/DbPassword: same username/password as for the DB Query node
DbUrl: jdbcdbc:MyDataSource where MyDataSource is the same as DbService in the DB Query node
DbDriver: sun.jdbc.odbc.JdbcOdbcDriver - don't know if this is the best driver to use - there seem to be many available


This doesn't work and I get the error "error: java.lang.UnsupportedOperationException".


Any suggestions what I'm doing wrong?


Thanks.
			

Hi there. I'm having the same problem.

Did anybody find a resolution for this issue?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: timonk

Darren,
If you are having this or a similar issue the best course is to contact the support line as specified in the above post and open an official ticket.

Regards,
Timon