  We use an anti-de Sitter/Quantum Chromodynamics (AdS/QCD) based holographic
light-front wavefunction (LFWF) for vector meson, in conjunction with the
dipole model to investigate the cross-sections data for the diffractive and
exclusive J/psi and Psi(2S) production. We confront the experimental data using
a new explicit form of the holographic LFWF, where the longitudinal confinement
dynamics in light-front Schrodinger equation is captured by 't Hooft equation
of (1+1)-dim, in large Nc approximation, in addition to the transverse
confinement dynamics governed by the confining mass scale parameter, kappa in
vector mesons. We obtain the LFWF parameters from fitting to the exclusive
J/psi electro production data from electron-proton collision at HERA collider
for m_c = 1.27 GeV. Our results suggest that the dipole model together with
holographic meson LFWFs with longitudinal confinement is able to give a
successful description for differential scattering cross-section for exclusive
J/psi electro production for H1 and ZEUS data. We also predict the rapidity
distributions of differential scattering cross-section and total photo
production of J/psi and Psi(2S) states in proton-proton ultra-peripheral
collisions(UPCs) at center of mass energy sqrt s = 7, 13 TeV. Using the minimum
set of parameters, our predictions for the UPCs are in good agreement with the
recent experimental observations of UPCs at ALICE and LHCb Collaborations.
