JBossDeveloper

thanks Ramesh

To view the MS Access data source in Model Explorer of Dev Studio though what driver am I using in the import wizard ?

jpgs attached in increasing order as they show in import wizard

thanks

sk

Had already the DSN laid out but I followed your helpful insight for the driver. I could not make it work using the driver name as " sun.jdbc.odbc.JdbcOdbcDriver" so in order to pick a driver I had to dig in ./jre/lib.rt.jar. After that I tried both the DSN-less and the DSN config way but although they both connect to the MS access db with a successful ping, they cannot finish (data source import wizard last window shows like in the jpg attached).

Also, it looks like only the 64bit odbc exe can be seen by Teiid when I use the data source import wizard. I tried both an mdb and an accdb version of the access sb but in all of the above cases I end up to the last import wizard window showing in the jpg but I cannot finish.

Would you recommend to create a datasource block in the standalone-ha.xml to circumvent the import wizard and config the data source manually ?

If I have to config the data source manually what would the steps be, if the above doesn't suffice ?

thanks as always

sk

I do hope you are using Windows with Oracle JDK for both Designer and as well as Teiid Server. Designer you would not need to do any thing else to find the driver, but in the Teiid Server, you need to edit "jboss-eap/modules/system/layers/base/org/jboss/teiid/translator/jdbc/main/module.xml" and add

<module name="sun.jdk"/>

under dependencies section, and restart the server.

Answer:

I am using jdk1.7.0_60 located at C:\Program Files\Java.

jre7 is also located C:\Program Files. Hopefully, this doesn't complicate things.

The server is a VMWare virtual machine and it runs Windows 2008 R2 EE

the path

jboss-eap/modules/system/layers/base/org/jboss/teiid/translator/jdbc/main doesn't exist on the windows server

I don't see teiid folder in jboss-eap/modules/system/layers/base/org/jboss

instead I added the line

<module name="sun.jdk"/> in the module.xml at the following location

jboss-eap/modules/system/layers/dv/org/jboss/teiid/translator/jdbc/main

see jpg attached for contents of module.xml

I'd like to also add that the server has no internet access and it'll never have, just in case that imposes any restriction and creates problems I can't think of.

> it looks like only the 64bit odbc exe can be seen by Teiid when I use the data source import wizard

I have no idea what you are saying here? Designer or Teiid does not look for any .exe file.

Answer:

Basically what I meant here is that when I created the system DSN with the 32bit ODBC windows admin tool from Ctrl Panel the import wizard on Dev. Studio could not see it. I had to create the system DSN using the 64bit ODBC tool and then it was recognized while going through the import wizard steps.

Back to the effort to import the MS access db as a separate data source. FYI, I have already a VDB stood up so the MS Access data source should be one more in it.

Also, as I said previously, before I got your previous response I had pulled the sun.jdbc.odbc.JdbcOdbcDriver from the rt.jat located in  the jdk1.7.0_60 folder.

Now I'm trying to create a new conn. profile but it always defaults to that older connection profile (that looks in the rt.jar) I had created. See jpgs attached.

The jpg numb increases as the wizard screens move forward. On the 3rd jpg clicking the Greek Delta symbol opens up the driver definition

jpgs 4 and 5 are showing the tabs of the "Edit Driver Definition" window

The connection URL and the database name are correct

In the connection URL "NICoEData" is the DSN name I have created with the 64bit ODBC

ha.xml to start up EAP because that would give me a cluster of 2 standalones that won't failover or load balance but in case one fails (as long as I'm keeping both standalone EAPs identical in all respects) I will be able to migrate to the other.

I need to work more on this as soon as I figure out the connectivity to MS Access and understand how to read the exec plans so I can perf tune queries.

thanks

sk

Hello Ramesh,

I followed the steps DSN - ODBC - JDBC/ODBC driver but it looks like the MS Access metadata doesn't show (see jpg attached) so I can't select any objects (tbls or views) to finish the import wizrd (method 1). I completed the work manually loading separate txt files by creating children in the VBLayer after I automated creating all the text for the SQL transformations using T-SQL for all tbls, but I'll try again going through the steps of Method 1 to make sure I am not forgetting something that prevents it from working properly.

A new Q.

Is there anywhere (on Teiid or JBOSS EAP) any JDBC connectivity access log that records who's connecting to a VDB via JDBC and whether the connection is successful or not?

I know the default accnt is user/user but if we create more accnts how can we know when and which one started a JDBC connection ?

thanks.

Thanks for your response Steve.

Please forgive my ignorance but when you say "start with a DDL export" do you mean exporting the DDL for all tbls from the MS Access db (in txt files for example) and then run an 'import DDL' from Teiid (in the Model Explorer) to import the metadata ?

Will the above help the jdbc-odbc bridge see the MS Access metadata and how or it's a solution in lieu of using the bridge?

I'll change the log level to ensure enough detail to capture user ids, etc. Thanks for your advice on this matter.

Wishes for a happy, prosperous and healthy New Yr to you and Ramesh.

System

Windows 2008 R2 EE

running JBOSS EAP 6.1.1.GA

with java jdk 1.7.0_71

Background

This request for assistance regards the process how to create a password vault. I'm following the process described by Redhat's official docs for EAP 6.3 as it shows at:

https://access.redhat.com/documentation/en-US/JBoss_Enterprise_Application_Platform/6.3/html/Security_Guide/chap-Secure_Passwords_and_Other_Sensitive_Strings_with_Password_Vault.html

My issue has been reported, almost identical, by another community member in the following thread:

_https://developer.jboss.org/thread/233583?start=0&tstart=0

I can only guess if it's finally answered or discussed in the following Redhat.com page

https://access.redhat.com/solutions/741613

because I'm not a Redhat subscriber, thus, I can't see the page contents.

The problem

On page (redhat doc. section 7.4) https://access.redhat.com/documentation/en-US/JBoss_Enterprise_Application_Platform/6.3/html/Security_Guide/Configure_the_Enterprise_Application_Platform_to_Use_the_Password_Vault1.html

for the "standalone server" case

the following command must execute in a mngt CLI command prompt

/core-service=vault:add(vault-options=[("KEYSTORE_URL" => "PATH_TO_KEYSTORE"), ("KEYSTORE_PASSWORD" => "MASKED_PASSWORD"), ("KEYSTORE_ALIAS" => "ALIAS"), ("SALT" => "SALT"),("ITERATION_COUNT" => "ITERATION_COUNT"), ("ENC_FILE_DIR" => "ENC_FILE_DIR")])

I have replaced all variables in the command above with the right values I got from the previous step, described in Redhat's doc. section 7.3, that BTW completed successfully.

I'm also doing what the green note says

If you use Microsoft Windows Server, in the CLI command, escape each \ character in a directory path with an additional \ character. For example, C:\\data\\vault\\vault.keystore. This is because single \ character is used for character escaping.

However, when I execute the above command I get a quick and short  error msg saying :

the closing '"' is missing  

The description of '"' is single quote double quote single quote.

Any ideas how I can resolve or circumvent this problem ?

Thanks

sk

Thanks Ramesh. It worked.

System

Windows 2008 R2 EE

JBOSS EAP 6.1.1.GA

java jdk 1.7.0_71

Problem

I am running vault.bat to create a password vault but after I supply all the answers according to this URL

https://access.redhat.com/documentation/en-US/JBoss_Enterprise_Application_Platform/6.3/html/Security_Guide/Store_and_Retrieve_Encrypted_Sensitive_Strings_in_the_Java_Keystore.html

at the end of the interactive session I get a NullPointerException error.

Potential Answer URL

Redhat looks like has an answer to this similar problem at https://access.redhat.com/solutions/535113

Any help is appreciated.

Thanks

SK